IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Seq]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[Seq]
END
GO

CREATE TABLE [dbo].[Seq](
	[SeqName]   [varchar](128) NOT NULL,
	[SeqNumber] [bigint] NOT NULL,
     CONSTRAINT [PK_Seq] PRIMARY KEY CLUSTERED ( [SeqName] ASC )
)
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique Identifier of a particular Sequence Name.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Seq', @level2type=N'COLUMN',@level2name=N'SeqName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Value of the Sequence Name.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Seq', @level2type=N'COLUMN',@level2name=N'SeqNumber'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains records for application controlled id values.  Effectively application controlled identity values.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Seq'
GO
